Desktop Computer Skills
Microsoft Office 2010: Beginning Excel
Adding Visuals, Themes, and Styles to Excel 2010 Workbooks
mo_bexl_a11_dt_enus
Applying Basic Data Formatting in Excel 2010
mo_bexl_a02_dt_enus
Excel 2010: Basic Formulas
ds_msex2010_09_enus
Excel 2010: Charts & Graphics
ds_msex2010_11_enus
Excel 2010: Conditional Formulas
ds_msex2010_13_enus
Excel 2010: Configuring Excel
ds_msex2010_15_enus
Excel 2010: Custom & Conditional Formatting
ds_msex2010_05_enus
Excel 2010: Extracting Information with Formulas
ds_msex2010_14_enus
Excel 2010: Finding, Sorting, & Filtering Data
ds_msex2010_07_enus
Excel 2010: Formatting Data
ds_msex2010_04_enus
Excel 2010: Getting Started
ds_msex2010_01_enus
Excel 2010: Illustrating Documents
ds_msex2010_06_enus
Excel 2010: Manipulating Data
ds_msex2010_03_enus
Excel 2010: PivotTables & PivotCharts
ds_msex2010_12_enus
Excel 2010: Referencing Data
ds_msex2010_08_enus
Excel 2010: Saving & Sharing Workbooks
ds_msex2010_02_enus
Excel 2010: Working with Formulas
ds_msex2010_10_enus
Getting Started with Excel 2010
mo_bexl_a01_dt_enus
Inserting Basic Charts in Excel 2010
mo_bexl_a10_dt_enus
Moving and Getting Around in Excel 2010
mo_bexl_a03_dt_enus
Moving Data and Modifying Worksheets in Excel 2010
mo_bexl_a04_dt_enus
Reviewing and Protecting Content in Excel 2010
mo_bexl_a07_dt_enus
Saving, Sending, and Printing Excel 2010 Workbooks
mo_bexl_a05_dt_enus
Using Basic Formulas in Excel 2010
mo_bexl_a08_dt_enus
Using Basic Functions with Excel 2010
mo_bexl_a09_dt_enus
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
mo_bexl_a06_dt_enus
Adding Visuals, Themes, and Styles to Excel 2010 Workbooks
Lesson Objectives
Adding Visuals, Themes, and Styles to Excel 2010 Workbooks
- insert illustrations, including pictures, clip art, shapes, and SmartArt graphics, into a worksheet
- use Excel's image editing tools to format illustrations
- insert a screenshot into a workbook
- add text features to a worksheet
- use cell styles to apply consistent formatting
- apply an Excel theme to a worksheet
- add a picture and clip art to a worksheet
- add a screenshot to a worksheet
- apply a theme and a cell style
Overview/Description
Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
Prerequisites: none
Adding Visuals, Themes, and Styles to Excel 2010 Workbooks
Lesson Objectives
Adding Visuals, Themes, and Styles to Excel 2010 Workbooks
- insert illustrations, including pictures, clip art, shapes, and SmartArt graphics, into a worksheet
- use Excel's image editing tools to format illustrations
- insert a screenshot into a workbook
- add text features to a worksheet
- use cell styles to apply consistent formatting
- apply an Excel theme to a worksheet
- add a picture and clip art to a worksheet
- add a screenshot to a worksheet
- apply a theme and a cell style
Overview/Description
Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
Prerequisites: none
Applying Basic Data Formatting in Excel 2010
Lesson Objectives
Applying Basic Data Formatting in Excel 2010
- apply basic text formatting
- apply and copy cell formatting
- recognize how alignment commands change the position of text
- apply and modify number formats
- match number formats with examples
- format text and cells
- align text in a cell
- modify and apply a number format
Overview/Description
Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in Excel 2010.
Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in Excel 2010.
Prerequisites: none
Applying Basic Data Formatting in Excel 2010
Lesson Objectives
Applying Basic Data Formatting in Excel 2010
- apply basic text formatting
- apply and copy cell formatting
- recognize how alignment commands change the position of text
- apply and modify number formats
- match number formats with examples
- format text and cells
- align text in a cell
- modify and apply a number format
Overview/Description
Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in Excel 2010.
Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in Excel 2010.
Prerequisites: none
Excel 2010: Basic Formulas
Lesson Objectives
Excel 2010: Basic Formulas
- Inserting a formula using the function library
- Performing simple calculations
- Using automated formulas in a table
- Creating automated cumulative totals
- Inserting subtotals
- Counting cells in a range
- Ranking a value
Overview/Description
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
Target
Prerequisites: none
Excel 2010: Basic Formulas
Lesson Objectives
Excel 2010: Basic Formulas
- Inserting a formula using the function library
- Performing simple calculations
- Using automated formulas in a table
- Creating automated cumulative totals
- Inserting subtotals
- Counting cells in a range
- Ranking a value
Overview/Description
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
Target
Prerequisites: none
Excel 2010: Basic Formulas
Lesson Objectives
Excel 2010: Basic Formulas
- Inserting a formula using the function library
- Performing simple calculations
- Using automated formulas in a table
- Creating automated cumulative totals
- Inserting subtotals
- Counting cells in a range
- Ranking a value
Overview/Description
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
Target
Prerequisites: none
Excel 2010: Basic Formulas
Lesson Objectives
Excel 2010: Basic Formulas
- Inserting a formula using the function library
- Performing simple calculations
- Using automated formulas in a table
- Creating automated cumulative totals
- Inserting subtotals
- Counting cells in a range
- Ranking a value
Overview/Description
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
Target
Prerequisites: none
Excel 2010: Charts & Graphics
Lesson Objectives
Excel 2010: Charts & Graphics
- Inserting your first chart
- Labeling your chart
- Formatting your chart
- Customizing your chart axes
- Customizing your chart titles
- Creating a chart template
- Presenting negative values in your chart
- Creating a pie chart
- Creating a scatter chart
- Creating a bubble chart
- Creating a radar chart
- Combining two types of chart
- Creating a comparative chart using symbols
- Inserting trendlines
- Customizing your trend lines
Overview/Description
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Target
Prerequisites: none
Excel 2010: Charts & Graphics
Lesson Objectives
Excel 2010: Charts & Graphics
- Inserting your first chart
- Labeling your chart
- Formatting your chart
- Customizing your chart axes
- Customizing your chart titles
- Creating a chart template
- Presenting negative values in your chart
- Creating a pie chart
- Creating a scatter chart
- Creating a bubble chart
- Creating a radar chart
- Combining two types of chart
- Creating a comparative chart using symbols
- Inserting trendlines
- Customizing your trend lines
Overview/Description
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Target
Prerequisites: none
Excel 2010: Charts & Graphics
Lesson Objectives
Excel 2010: Charts & Graphics
- Inserting your first chart
- Labeling your chart
- Formatting your chart
- Customizing your chart axes
- Customizing your chart titles
- Creating a chart template
- Presenting negative values in your chart
- Creating a pie chart
- Creating a scatter chart
- Creating a bubble chart
- Creating a radar chart
- Combining two types of chart
- Creating a comparative chart using symbols
- Inserting trendlines
- Customizing your trend lines
Overview/Description
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Target
Prerequisites: none
Excel 2010: Charts & Graphics
Lesson Objectives
Excel 2010: Charts & Graphics
- Inserting your first chart
- Labeling your chart
- Formatting your chart
- Customizing your chart axes
- Customizing your chart titles
- Creating a chart template
- Presenting negative values in your chart
- Creating a pie chart
- Creating a scatter chart
- Creating a bubble chart
- Creating a radar chart
- Combining two types of chart
- Creating a comparative chart using symbols
- Inserting trendlines
- Customizing your trend lines
Overview/Description
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Target
Prerequisites: none
Excel 2010: Conditional Formulas
Lesson Objectives
Excel 2010: Conditional Formulas
- Inserting a conditional sum formula
- Inserting a conditional message formula
- Performing complex conditional formulas
- Creating multiple conditions
- Using IF & OR in conditional formulas
- Using conditional formulas to count up value occurrences
- Translating data in your worksheet
- Using reference positions in conditional formulas
- Keeping your table up to date with conditional formulas
Overview/Description
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, translate data, and keep tables up-to-date in Excel.
Target
Prerequisites: none
Excel 2010: Conditional Formulas
Lesson Objectives
Excel 2010: Conditional Formulas
- Inserting a conditional sum formula
- Inserting a conditional message formula
- Performing complex conditional formulas
- Creating multiple conditions
- Using IF & OR in conditional formulas
- Using conditional formulas to count up value occurrences
- Translating data in your worksheet
- Using reference positions in conditional formulas
- Keeping your table up to date with conditional formulas
Overview/Description
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, translate data, and keep tables up-to-date in Excel.
Target
Prerequisites: none
Excel 2010: Conditional Formulas
Lesson Objectives
Excel 2010: Conditional Formulas
- Inserting a conditional sum formula
- Inserting a conditional message formula
- Performing complex conditional formulas
- Creating multiple conditions
- Using IF & OR in conditional formulas
- Using conditional formulas to count up value occurrences
- Translating data in your worksheet
- Using reference positions in conditional formulas
- Keeping your table up to date with conditional formulas
Overview/Description
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, translate data, and keep tables up-to-date in Excel.
Target
Prerequisites: none
Excel 2010: Conditional Formulas
Lesson Objectives
Excel 2010: Conditional Formulas
- Inserting a conditional sum formula
- Inserting a conditional message formula
- Performing complex conditional formulas
- Creating multiple conditions
- Using IF & OR in conditional formulas
- Using conditional formulas to count up value occurrences
- Translating data in your worksheet
- Using reference positions in conditional formulas
- Keeping your table up to date with conditional formulas
Overview/Description
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, translate data, and keep tables up-to-date in Excel.
Target
Prerequisites: none
Excel 2010: Configuring Excel
Lesson Objectives
Excel 2010: Configuring Excel
- Adjusting your input options
- Customizing your document view settings
- Customizing your interface
- Customizing the Quick Access toolbar
- Customizing the ribbon
Overview/Description
Excel can be customized to suit the user's preferences and work habits. Discover how to adjust the input options, document view settings, interface, ribbon, and Quick Access toolbar.
Target
Prerequisites: none
Excel 2010: Configuring Excel
Lesson Objectives
Excel 2010: Configuring Excel
- Adjusting your input options
- Customizing your document view settings
- Customizing your interface
- Customizing the Quick Access toolbar
- Customizing the ribbon
Overview/Description
Excel can be customized to suit the user's preferences and work habits. Discover how to adjust the input options, document view settings, interface, ribbon, and Quick Access toolbar.
Target
Prerequisites: none
Excel 2010: Configuring Excel
Lesson Objectives
Excel 2010: Configuring Excel
- Adjusting your input options
- Customizing your document view settings
- Customizing your interface
- Customizing the Quick Access toolbar
- Customizing the ribbon
Overview/Description
Excel can be customized to suit the user's preferences and work habits. Discover how to adjust the input options, document view settings, interface, ribbon, and Quick Access toolbar.
Target
Prerequisites: none
Excel 2010: Configuring Excel
Lesson Objectives
Excel 2010: Configuring Excel
- Adjusting your input options
- Customizing your document view settings
- Customizing your interface
- Customizing the Quick Access toolbar
- Customizing the ribbon
Overview/Description
Excel can be customized to suit the user's preferences and work habits. Discover how to adjust the input options, document view settings, interface, ribbon, and Quick Access toolbar.
Target
Prerequisites: none
Excel 2010: Custom & Conditional Formatting
Lesson Objectives
Excel 2010: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing the date & time formats
- Creating conditional custom formats
- Using the conditional formatting options
- Using advanced conditional formatting
- Applying color to the first new entry in a list
Overview/Description
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
Target
Prerequisites: none
Excel 2010: Custom & Conditional Formatting
Lesson Objectives
Excel 2010: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing the date & time formats
- Creating conditional custom formats
- Using the conditional formatting options
- Using advanced conditional formatting
- Applying color to the first new entry in a list
Overview/Description
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
Target
Prerequisites: none
Excel 2010: Custom & Conditional Formatting
Lesson Objectives
Excel 2010: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing the date & time formats
- Creating conditional custom formats
- Using the conditional formatting options
- Using advanced conditional formatting
- Applying color to the first new entry in a list
Overview/Description
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
Target
Prerequisites: none
Excel 2010: Custom & Conditional Formatting
Lesson Objectives
Excel 2010: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing the date & time formats
- Creating conditional custom formats
- Using the conditional formatting options
- Using advanced conditional formatting
- Applying color to the first new entry in a list
Overview/Description
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
Target
Prerequisites: none
Excel 2010: Extracting Information with Formulas
Lesson Objectives
Excel 2010: Extracting Information with Formulas
- Retrieving information with dates
- Finding a date automatically
- Finding the largest & smallest values in a list
- Separating data into multiple cells
- Combining data in a single cell
- Retrieving information on a cell
- Retrieving information on your text
- Cross referencing two data lists
- Inserting data automatically
- Finding a value in a double entry table
- Performing a search across two tables
- Finding data in a database
- Performing calculations using your database
Overview/Description
Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.
Target
Prerequisites: none
Excel 2010: Extracting Information with Formulas
Lesson Objectives
Excel 2010: Extracting Information with Formulas
- Retrieving information with dates
- Finding a date automatically
- Finding the largest & smallest values in a list
- Separating data into multiple cells
- Combining data in a single cell
- Retrieving information on a cell
- Retrieving information on your text
- Cross referencing two data lists
- Inserting data automatically
- Finding a value in a double entry table
- Performing a search across two tables
- Finding data in a database
- Performing calculations using your database
Overview/Description
Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.
Target
Prerequisites: none
Excel 2010: Extracting Information with Formulas
Lesson Objectives
Excel 2010: Extracting Information with Formulas
- Retrieving information with dates
- Finding a date automatically
- Finding the largest & smallest values in a list
- Separating data into multiple cells
- Combining data in a single cell
- Retrieving information on a cell
- Retrieving information on your text
- Cross referencing two data lists
- Inserting data automatically
- Finding a value in a double entry table
- Performing a search across two tables
- Finding data in a database
- Performing calculations using your database
Overview/Description
Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.
Target
Prerequisites: none
Excel 2010: Extracting Information with Formulas
Lesson Objectives
Excel 2010: Extracting Information with Formulas
- Retrieving information with dates
- Finding a date automatically
- Finding the largest & smallest values in a list
- Separating data into multiple cells
- Combining data in a single cell
- Retrieving information on a cell
- Retrieving information on your text
- Cross referencing two data lists
- Inserting data automatically
- Finding a value in a double entry table
- Performing a search across two tables
- Finding data in a database
- Performing calculations using your database
Overview/Description
Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.
Target
Prerequisites: none
Excel 2010: Finding, Sorting, & Filtering Data
Lesson Objectives
Excel 2010: Finding, Sorting, & Filtering Data
- Using the Find tool
- Using the Replace tool
- Using the Find & Replace tools in a formula
- Sorting data in a table
- Filtering data in a table
- Sorting & filtering using colors
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping elements & creating a plan
Overview/Description
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
Target
Prerequisites: none
Excel 2010: Finding, Sorting, & Filtering Data
Lesson Objectives
Excel 2010: Finding, Sorting, & Filtering Data
- Using the Find tool
- Using the Replace tool
- Using the Find & Replace tools in a formula
- Sorting data in a table
- Filtering data in a table
- Sorting & filtering using colors
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping elements & creating a plan
Overview/Description
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
Target
Prerequisites: none
Excel 2010: Finding, Sorting, & Filtering Data
Lesson Objectives
Excel 2010: Finding, Sorting, & Filtering Data
- Using the Find tool
- Using the Replace tool
- Using the Find & Replace tools in a formula
- Sorting data in a table
- Filtering data in a table
- Sorting & filtering using colors
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping elements & creating a plan
Overview/Description
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
Target
Prerequisites: none
Excel 2010: Finding, Sorting, & Filtering Data
Lesson Objectives
Excel 2010: Finding, Sorting, & Filtering Data
- Using the Find tool
- Using the Replace tool
- Using the Find & Replace tools in a formula
- Sorting data in a table
- Filtering data in a table
- Sorting & filtering using colors
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping elements & creating a plan
Overview/Description
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
Target
Prerequisites: none
Excel 2010: Formatting Data
Lesson Objectives
Excel 2010: Formatting Data
- Setting your data type
- Formatting data
- Aligning your data
- Customizing text colors & fill options
- Changing your cell style
- Using document themes
- Using formulas to modify your text case
- Creating a title
- Formatting a title
- Creating a table
- Resizing columns & rows
- Inserting columns & rows
- Inserting borders
- Transferring styles
Overview/Description
You can make your data more meaningful by changing its appearance in the spreadsheet. Discover how to set data type, format data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.
Target
Prerequisites: none
Excel 2010: Formatting Data
Lesson Objectives
Excel 2010: Formatting Data
- Setting your data type
- Formatting data
- Aligning your data
- Customizing text colors & fill options
- Changing your cell style
- Using document themes
- Using formulas to modify your text case
- Creating a title
- Formatting a title
- Creating a table
- Resizing columns & rows
- Inserting columns & rows
- Inserting borders
- Transferring styles
Overview/Description
You can make your data more meaningful by changing its appearance in the spreadsheet. Discover how to set data type, format data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.
Target
Prerequisites: none
Excel 2010: Formatting Data
Lesson Objectives
Excel 2010: Formatting Data
- Setting your data type
- Formatting data
- Aligning your data
- Customizing text colors & fill options
- Changing your cell style
- Using document themes
- Using formulas to modify your text case
- Creating a title
- Formatting a title
- Creating a table
- Resizing columns & rows
- Inserting columns & rows
- Inserting borders
- Transferring styles
Overview/Description
You can make your data more meaningful by changing its appearance in the spreadsheet. Discover how to set data type, format data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.
Target
Prerequisites: none
Excel 2010: Formatting Data
Lesson Objectives
Excel 2010: Formatting Data
- Setting your data type
- Formatting data
- Aligning your data
- Customizing text colors & fill options
- Changing your cell style
- Using document themes
- Using formulas to modify your text case
- Creating a title
- Formatting a title
- Creating a table
- Resizing columns & rows
- Inserting columns & rows
- Inserting borders
- Transferring styles
Overview/Description
You can make your data more meaningful by changing its appearance in the spreadsheet. Discover how to set data type, format data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.
Target
Prerequisites: none
Excel 2010: Getting Started
Lesson Objectives
Excel 2010: Getting Started
- Finding & opening the application
- Using Excel 2010
- Using the zoom function
- Using the view modes
- Moving between windows
Overview/Description
Get started with Excel 2010, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.
Target
Prerequisites: none
Excel 2010: Getting Started
Lesson Objectives
Excel 2010: Getting Started
- Finding & opening the application
- Using Excel 2010
- Using the zoom function
- Using the view modes
- Moving between windows
Overview/Description
Get started with Excel 2010, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.
Target
Prerequisites: none
Excel 2010: Getting Started
Lesson Objectives
Excel 2010: Getting Started
- Finding & opening the application
- Using Excel 2010
- Using the zoom function
- Using the view modes
- Moving between windows
Overview/Description
Get started with Excel 2010, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.
Target
Prerequisites: none
Excel 2010: Getting Started
Lesson Objectives
Excel 2010: Getting Started
- Finding & opening the application
- Using Excel 2010
- Using the zoom function
- Using the view modes
- Moving between windows
Overview/Description
Get started with Excel 2010, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.
Target
Prerequisites: none
Excel 2010: Illustrating Documents
Lesson Objectives
Excel 2010: Illustrating Documents
- Inserting an image
- Inserting a screenshot
- Editing an image
- Inserting shapes
- Inserting a hyperlink
Overview/Description
There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, diagrams, and hyperlinks.
Target
Prerequisites: none
Excel 2010: Illustrating Documents
Lesson Objectives
Excel 2010: Illustrating Documents
- Inserting an image
- Inserting a screenshot
- Editing an image
- Inserting shapes
- Inserting a hyperlink
Overview/Description
There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, diagrams, and hyperlinks.
Target
Prerequisites: none
Excel 2010: Illustrating Documents
Lesson Objectives
Excel 2010: Illustrating Documents
- Inserting an image
- Inserting a screenshot
- Editing an image
- Inserting shapes
- Inserting a hyperlink
Overview/Description
There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, diagrams, and hyperlinks.
Target
Prerequisites: none
Excel 2010: Illustrating Documents
Lesson Objectives
Excel 2010: Illustrating Documents
- Inserting an image
- Inserting a screenshot
- Editing an image
- Inserting shapes
- Inserting a hyperlink
Overview/Description
There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, diagrams, and hyperlinks.
Target
Prerequisites: none
Excel 2010: Manipulating Data
Lesson Objectives
Excel 2010: Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the AutoComplete function
- Inserting dropdown menus
- Using the spell check tool
- Using AutoCorrect
- Transferring data
- Transferring data between sheets
- Copying & pasting values
- Transposing data
- Consolidating your data
Overview/Description
It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.
Target
Prerequisites: none
Excel 2010: Manipulating Data
Lesson Objectives
Excel 2010: Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the AutoComplete function
- Inserting dropdown menus
- Using the spell check tool
- Using AutoCorrect
- Transferring data
- Transferring data between sheets
- Copying & pasting values
- Transposing data
- Consolidating your data
Overview/Description
It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.
Target
Prerequisites: none
Excel 2010: Manipulating Data
Lesson Objectives
Excel 2010: Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the AutoComplete function
- Inserting dropdown menus
- Using the spell check tool
- Using AutoCorrect
- Transferring data
- Transferring data between sheets
- Copying & pasting values
- Transposing data
- Consolidating your data
Overview/Description
It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.
Target
Prerequisites: none
Excel 2010: Manipulating Data
Lesson Objectives
Excel 2010: Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the AutoComplete function
- Inserting dropdown menus
- Using the spell check tool
- Using AutoCorrect
- Transferring data
- Transferring data between sheets
- Copying & pasting values
- Transposing data
- Consolidating your data
Overview/Description
It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.
Target
Prerequisites: none
Excel 2010: PivotTables & PivotCharts
Lesson Objectives
Excel 2010: PivotTables & PivotCharts
- Creating a PivotTable
- Editing your PivotTable
- Formatting your PivotTable
- Comparing values in a PivotTable
- Copying & reusing your PivotTable
- Inserting a calculation in your PivotTable
- Sorting data in your PivotTable
- Filtering your PivotTable data
- Grouping data in your PivotTable
- Inserting a slicer
- Customizing a slicer
- Inserting a PivotChart
- Modifying your PivotChart
- Analyzing your database tables in a PivotChart
Overview/Description
A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.
Target
Prerequisites: none
Excel 2010: PivotTables & PivotCharts
Lesson Objectives
Excel 2010: PivotTables & PivotCharts
- Creating a PivotTable
- Editing your PivotTable
- Formatting your PivotTable
- Comparing values in a PivotTable
- Copying & reusing your PivotTable
- Inserting a calculation in your PivotTable
- Sorting data in your PivotTable
- Filtering your PivotTable data
- Grouping data in your PivotTable
- Inserting a slicer
- Customizing a slicer
- Inserting a PivotChart
- Modifying your PivotChart
- Analyzing your database tables in a PivotChart
Overview/Description
A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.
Target
Prerequisites: none
Excel 2010: PivotTables & PivotCharts
Lesson Objectives
Excel 2010: PivotTables & PivotCharts
- Creating a PivotTable
- Editing your PivotTable
- Formatting your PivotTable
- Comparing values in a PivotTable
- Copying & reusing your PivotTable
- Inserting a calculation in your PivotTable
- Sorting data in your PivotTable
- Filtering your PivotTable data
- Grouping data in your PivotTable
- Inserting a slicer
- Customizing a slicer
- Inserting a PivotChart
- Modifying your PivotChart
- Analyzing your database tables in a PivotChart
Overview/Description
A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.
Target
Prerequisites: none
Excel 2010: PivotTables & PivotCharts
Lesson Objectives
Excel 2010: PivotTables & PivotCharts
- Creating a PivotTable
- Editing your PivotTable
- Formatting your PivotTable
- Comparing values in a PivotTable
- Copying & reusing your PivotTable
- Inserting a calculation in your PivotTable
- Sorting data in your PivotTable
- Filtering your PivotTable data
- Grouping data in your PivotTable
- Inserting a slicer
- Customizing a slicer
- Inserting a PivotChart
- Modifying your PivotChart
- Analyzing your database tables in a PivotChart
Overview/Description
A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.
Target
Prerequisites: none
Excel 2010: Referencing Data
Lesson Objectives
Excel 2010: Referencing Data
- Referencing your cells
- Using data across multiple sheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constants
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Overview/Description
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.
Target
Prerequisites: none
Excel 2010: Referencing Data
Lesson Objectives
Excel 2010: Referencing Data
- Referencing your cells
- Using data across multiple sheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constants
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Overview/Description
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.
Target
Prerequisites: none
Excel 2010: Referencing Data
Lesson Objectives
Excel 2010: Referencing Data
- Referencing your cells
- Using data across multiple sheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constants
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Overview/Description
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.
Target
Prerequisites: none
Excel 2010: Referencing Data
Lesson Objectives
Excel 2010: Referencing Data
- Referencing your cells
- Using data across multiple sheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constants
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Overview/Description
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.
Target
Prerequisites: none
Excel 2010: Saving & Sharing Workbooks
Lesson Objectives
Excel 2010: Saving & Sharing Workbooks
- Using predefined templates
- Managing your sheets
- Saving your document
- Saving your file as a PDF
- Recovering a previous version of your document
- Inserting footers & headers
- Setting your print area & table layout
- Adjusting your page layout
- Printing your document
- Checking for compatibility issues
- Accessing & editing your document's properties
- Checking for personal information in your document
- Creating an accessible document
- Protecting your document
- Sharing your document via email
- Adding a comment to the document
- Adding a comment to the document
Overview/Description
There are numerous ways to set up a document in Excel. Discover how to save, share, and manage your documents with Excel 2010.
Target
Prerequisites: none
Excel 2010: Saving & Sharing Workbooks
Lesson Objectives
Excel 2010: Saving & Sharing Workbooks
- Using predefined templates
- Managing your sheets
- Saving your document
- Saving your file as a PDF
- Recovering a previous version of your document
- Inserting footers & headers
- Setting your print area & table layout
- Adjusting your page layout
- Printing your document
- Checking for compatibility issues
- Accessing & editing your document's properties
- Checking for personal information in your document
- Creating an accessible document
- Protecting your document
- Sharing your document via email
- Adding a comment to the document
- Adding a comment to the document
Overview/Description
There are numerous ways to set up a document in Excel. Discover how to save, share, and manage your documents with Excel 2010.
Target
Prerequisites: none
Excel 2010: Saving & Sharing Workbooks
Lesson Objectives
Excel 2010: Saving & Sharing Workbooks
- Using predefined templates
- Managing your sheets
- Saving your document
- Saving your file as a PDF
- Recovering a previous version of your document
- Inserting footers & headers
- Setting your print area & table layout
- Adjusting your page layout
- Printing your document
- Checking for compatibility issues
- Accessing & editing your document's properties
- Checking for personal information in your document
- Creating an accessible document
- Protecting your document
- Sharing your document via email
- Adding a comment to the document
- Adding a comment to the document
Overview/Description
There are numerous ways to set up a document in Excel. Discover how to save, share, and manage your documents with Excel 2010.
Target
Prerequisites: none
Excel 2010: Saving & Sharing Workbooks
Lesson Objectives
Excel 2010: Saving & Sharing Workbooks
- Using predefined templates
- Managing your sheets
- Saving your document
- Saving your file as a PDF
- Recovering a previous version of your document
- Inserting footers & headers
- Setting your print area & table layout
- Adjusting your page layout
- Printing your document
- Checking for compatibility issues
- Accessing & editing your document's properties
- Checking for personal information in your document
- Creating an accessible document
- Protecting your document
- Sharing your document via email
- Adding a comment to the document
- Adding a comment to the document
Overview/Description
There are numerous ways to set up a document in Excel. Discover how to save, share, and manage your documents with Excel 2010.
Target
Prerequisites: none
Excel 2010: Working with Formulas
Lesson Objectives
Excel 2010: Working with Formulas
- Calculating the interest on a loan
- Simulating a loan
- Reaching a target figure
- Solving a problem
- Creating automatic reports
- Finding identical values in your spreadsheet
- Visualizing duplicates in your document
- Visualizing your duplicate values
- Preventing duplicate values
Overview/Description
Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, solve problems, and prevent duplicate values.
Target
Prerequisites: none
Excel 2010: Working with Formulas
Lesson Objectives
Excel 2010: Working with Formulas
- Calculating the interest on a loan
- Simulating a loan
- Reaching a target figure
- Solving a problem
- Creating automatic reports
- Finding identical values in your spreadsheet
- Visualizing duplicates in your document
- Visualizing your duplicate values
- Preventing duplicate values
Overview/Description
Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, solve problems, and prevent duplicate values.
Target
Prerequisites: none
Excel 2010: Working with Formulas
Lesson Objectives
Excel 2010: Working with Formulas
- Calculating the interest on a loan
- Simulating a loan
- Reaching a target figure
- Solving a problem
- Creating automatic reports
- Finding identical values in your spreadsheet
- Visualizing duplicates in your document
- Visualizing your duplicate values
- Preventing duplicate values
Overview/Description
Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, solve problems, and prevent duplicate values.
Target
Prerequisites: none
Excel 2010: Working with Formulas
Lesson Objectives
Excel 2010: Working with Formulas
- Calculating the interest on a loan
- Simulating a loan
- Reaching a target figure
- Solving a problem
- Creating automatic reports
- Finding identical values in your spreadsheet
- Visualizing duplicates in your document
- Visualizing your duplicate values
- Preventing duplicate values
Overview/Description
Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, solve problems, and prevent duplicate values.
Target
Prerequisites: none
Getting Started with Excel 2010
Lesson Objectives
Getting Started with Excel 2010
- start Excel 2010 and open an existing workbook
- identify the features of spreadsheets
- recognize the functions of key Excel 2010 interface elements
- create a new workbook
- enter data in a given scenario
- open a workbook based on an existing template
- open an Excel workbook
- enter data into an Excel workbook
Overview/Description
Excel 2010 is the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively.
Excel 2010 is the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively.
Prerequisites: none
Getting Started with Excel 2010
Lesson Objectives
Getting Started with Excel 2010
- start Excel 2010 and open an existing workbook
- identify the features of spreadsheets
- recognize the functions of key Excel 2010 interface elements
- create a new workbook
- enter data in a given scenario
- open a workbook based on an existing template
- open an Excel workbook
- enter data into an Excel workbook
Overview/Description
Excel 2010 is the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively.
Excel 2010 is the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively.
Prerequisites: none
Inserting Basic Charts in Excel 2010
Lesson Objectives
Inserting Basic Charts in Excel 2010
- recognize when to use different Excel charts
- insert a chart
- identify the elements of an Excel chart
- update an existing Excel chart's style, layout, or location
- change the data range on which a chart is based
- insert a chart
- update a chart's type, layout, and style
- update the chart's source data and change chart's location
Overview/Description
Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualization of your data.
Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualization of your data.
Prerequisites: none
Inserting Basic Charts in Excel 2010
Lesson Objectives
Inserting Basic Charts in Excel 2010
- recognize when to use different Excel charts
- insert a chart
- identify the elements of an Excel chart
- update an existing Excel chart's style, layout, or location
- change the data range on which a chart is based
- insert a chart
- update a chart's type, layout, and style
- update the chart's source data and change chart's location
Overview/Description
Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualization of your data.
Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualization of your data.
Prerequisites: none
Moving and Getting Around in Excel 2010
Lesson Objectives
Moving and Getting Around in Excel 2010
- move around a worksheet
- recognize how to navigate around Excel in a given scenario
- get Help on Excel tasks or commands
- alter your view of the worksheet
- recognize how Workbook Views alter the appearance of a worksheet
- recognize how to zoom in or out of a worksheet
- work with different windows in Excel 2010
- work with panes in Excel workbooks
- move around a worksheet
- alter your view of a worksheet
- arrange and view workbook data
Overview/Description
While it can look complicated and daunting, navigating the Excel interface isn't as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features.
While it can look complicated and daunting, navigating the Excel interface isn't as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features.
Prerequisites: none
Moving and Getting Around in Excel 2010
Lesson Objectives
Moving and Getting Around in Excel 2010
- move around a worksheet
- recognize how to navigate around Excel in a given scenario
- get Help on Excel tasks or commands
- alter your view of the worksheet
- recognize how Workbook Views alter the appearance of a worksheet
- recognize how to zoom in or out of a worksheet
- work with different windows in Excel 2010
- work with panes in Excel workbooks
- move around a worksheet
- alter your view of a worksheet
- arrange and view workbook data
Overview/Description
While it can look complicated and daunting, navigating the Excel interface isn't as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features.
While it can look complicated and daunting, navigating the Excel interface isn't as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features.
Prerequisites: none
Moving Data and Modifying Worksheets in Excel 2010
Lesson Objectives
Moving Data and Modifying Worksheets in Excel 2010
- copy and move data
- use paste options to preview and control how data displays
- insert and delete rows and columns
- format rows and columns
- insert and delete worksheets
- copy or move worksheets
- copy and paste data
- modify rows and columns
- copy and modify worksheets
Overview/Description
The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if it's copied between Office applications, and the Paste Special option allows you to further define how your data is copied or moved. This course is designed to show you many of the ways that Excel 2010 allows you to manipulate data and the worksheets that contain them and describes features that let you do this quickly and efficiently.
The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if it's copied between Office applications, and the Paste Special option allows you to further define how your data is copied or moved. This course is designed to show you many of the ways that Excel 2010 allows you to manipulate data and the worksheets that contain them and describes features that let you do this quickly and efficiently.
Prerequisites: none
Moving Data and Modifying Worksheets in Excel 2010
Lesson Objectives
Moving Data and Modifying Worksheets in Excel 2010
- copy and move data
- use paste options to preview and control how data displays
- insert and delete rows and columns
- format rows and columns
- insert and delete worksheets
- copy or move worksheets
- copy and paste data
- modify rows and columns
- copy and modify worksheets
Overview/Description
The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if it's copied between Office applications, and the Paste Special option allows you to further define how your data is copied or moved. This course is designed to show you many of the ways that Excel 2010 allows you to manipulate data and the worksheets that contain them and describes features that let you do this quickly and efficiently.
The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if it's copied between Office applications, and the Paste Special option allows you to further define how your data is copied or moved. This course is designed to show you many of the ways that Excel 2010 allows you to manipulate data and the worksheets that contain them and describes features that let you do this quickly and efficiently.
Prerequisites: none
Reviewing and Protecting Content in Excel 2010
Lesson Objectives
Reviewing and Protecting Content in Excel 2010
- use Excel's proofing tools
- use the Excel comments feature
- use track changes in Excel 2010
- select statements that describe Excel's track changes tool
- apply worksheet and workbook protection
- check spelling in worksheet and add notes using comments
- use Excel's track changes feature
- protect elements of a worksheet
Overview/Description
Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
Prerequisites: none
Reviewing and Protecting Content in Excel 2010
Lesson Objectives
Reviewing and Protecting Content in Excel 2010
- use Excel's proofing tools
- use the Excel comments feature
- use track changes in Excel 2010
- select statements that describe Excel's track changes tool
- apply worksheet and workbook protection
- check spelling in worksheet and add notes using comments
- use Excel's track changes feature
- protect elements of a worksheet
Overview/Description
Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
Prerequisites: none
Saving, Sending, and Printing Excel 2010 Workbooks
Lesson Objectives
Saving, Sending, and Printing Excel 2010 Workbooks
- save a workbook in a different format
- save an Excel workbook
- change the default save options in Excel 2010
- share and send a workbook
- use the Page Setup settings to prepare a worksheet for printing
- print an Excel 2010 workbook
- save a workbook
- share a workbook
- prepare and print a workbook
Overview/Description
Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options – saving, printing, and sharing – are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and productivity.
Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options – saving, printing, and sharing – are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and productivity.
Prerequisites: none
Saving, Sending, and Printing Excel 2010 Workbooks
Lesson Objectives
Saving, Sending, and Printing Excel 2010 Workbooks
- save a workbook in a different format
- save an Excel workbook
- change the default save options in Excel 2010
- share and send a workbook
- use the Page Setup settings to prepare a worksheet for printing
- print an Excel 2010 workbook
- save a workbook
- share a workbook
- prepare and print a workbook
Overview/Description
Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options – saving, printing, and sharing – are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and productivity.
Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options – saving, printing, and sharing – are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and productivity.
Prerequisites: none
Using Basic Formulas in Excel 2010
Lesson Objectives
Using Basic Formulas in Excel 2010
- identify elements of a formula
- recognize how Excel calculates precedence in a formula
- recognize examples of reference types used in Excel formulas
- create and insert formulas
- use names in formulas
- correct common error values
- edit formulas
- create a formula
- define a name reference and use it in a formula
- copy and paste a formula between cells
Overview/Description
Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.
Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.
Prerequisites: none
Using Basic Formulas in Excel 2010
Lesson Objectives
Using Basic Formulas in Excel 2010
- identify elements of a formula
- recognize how Excel calculates precedence in a formula
- recognize examples of reference types used in Excel formulas
- create and insert formulas
- use names in formulas
- correct common error values
- edit formulas
- create a formula
- define a name reference and use it in a formula
- copy and paste a formula between cells
Overview/Description
Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.
Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.
Prerequisites: none
Using Basic Functions with Excel 2010
Lesson Objectives
Using Basic Functions with Excel 2010
- identify the characteristics of functions in Excel
- perform basic calculations using Excel's most commonly used functions
- use financial functions
- use date and time functions
- use logical functions to help perform calculations on worksheet data
- perform basic calculations
- use a financial function to determine the monthly repayment of a loan
- use a date function and a logical function
Overview/Description
One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to chose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.
One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to chose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.
Prerequisites: none
Using Basic Functions with Excel 2010
Lesson Objectives
Using Basic Functions with Excel 2010
- identify the characteristics of functions in Excel
- perform basic calculations using Excel's most commonly used functions
- use financial functions
- use date and time functions
- use logical functions to help perform calculations on worksheet data
- perform basic calculations
- use a financial function to determine the monthly repayment of a loan
- use a date function and a logical function
Overview/Description
One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to chose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.
One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to chose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.
Prerequisites: none
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
Lesson Objectives
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
- format data as a table
- sort and filter table data in a given scenario
- apply conditional formatting rules
- recognize when to use specific conditional formats
- use sparklines to show data trends
- format sparklines
- sort and filter table data
- use conditional formats to highlight data
- use sparklines to highlight trends in data
Overview/Description
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features – tables, styles, conditional formatting, and sparklines – how to access them and how to use them, are covered in this course.
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features – tables, styles, conditional formatting, and sparklines – how to access them and how to use them, are covered in this course.
Prerequisites: none
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
Lesson Objectives
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
- format data as a table
- sort and filter table data in a given scenario
- apply conditional formatting rules
- recognize when to use specific conditional formats
- use sparklines to show data trends
- format sparklines
- sort and filter table data
- use conditional formats to highlight data
- use sparklines to highlight trends in data
Overview/Description
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features – tables, styles, conditional formatting, and sparklines – how to access them and how to use them, are covered in this course.
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features – tables, styles, conditional formatting, and sparklines – how to access them and how to use them, are covered in this course.
Prerequisites: none
